Spread WPF Documentation
Evaluate(Object[]) Method


GrapeCity.CalcEngine.Functions Namespace > CalcOffsetFunction Class > Evaluate Method : Evaluate(Object[]) Method

The args contains 3 - 5 items: reference, rows, cols, [height], [width].

Reference is the reference from which you want to base the offset.

Rows is the number of rows, up or down, that you want the upper-left cell to refer to.

Cols is the number of columns, to the left or right, that you want the upper-left cell of the result to refer to.

[Height] is the height, in number of rows, that you want the returned reference to be. Height must be a positive number.

[Width] is the width, in number of columns, that you want the returned reference to be. Width must be a positive number.

Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.
Syntax
'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As System.Object _
) As System.Object
'Usage
 
Dim instance As CalcOffsetFunction
Dim args() As System.Object
Dim value As System.Object
 
value = instance.Evaluate(args)
public override System.object Evaluate( 
   System.object[] args
)

Parameters

args

The args contains 3 - 5 items: reference, rows, cols, [height], [width].

Reference is the reference from which you want to base the offset.

Rows is the number of rows, up or down, that you want the upper-left cell to refer to.

Cols is the number of columns, to the left or right, that you want the upper-left cell of the result to refer to.

[Height] is the height, in number of rows, that you want the returned reference to be. Height must be a positive number.

[Width] is the width, in number of columns, that you want the returned reference to be. Width must be a positive number.

Return Value

A GrapeCity.CalcEngine.CalcReference value that indicates the evaluate result.
See Also

Reference

CalcOffsetFunction Class
CalcOffsetFunction Members
Overload List